﻿CREATE TABLE [dbo].[WxPayFeedbackLog]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY, 
    [AppId] NVARCHAR(50) NULL, 
    [TimeStamp] NVARCHAR(50) NULL, 
    [OpenId] NVARCHAR(50) NULL, 
    [AppSignature] NVARCHAR(50) NULL, 
    [MsgType] NVARCHAR(50) NULL, 
    [FeedBackId ] NVARCHAR(50) NULL, 
    [TransId] NVARCHAR(50) NULL, 
    [Reason] NVARCHAR(500) NULL, 
    [Solution] NVARCHAR(500) NULL, 
    [ExtInfo] NVARCHAR(500) NULL, 
    [PicUrl ] NVARCHAR(1000) NULL, 
    [RecCreateDt] DATETIME NULL
)

GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'主键，自增长',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'WxPayFeedbackLog',
    @level2type = N'COLUMN',
    @level2name = N'Id'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'字段名称：公众号 id；字段来源：商户注册具有支付权限的公众号成功后即可获得；传入方式：由商户直接传入',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'WxPayFeedbackLog',
    @level2type = N'COLUMN',
    @level2name = N'AppId'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'字段名称：时间戳；字段来源：商户生成从 1970 年 1 月 1日 00：00：00 至今的秒数，即当前的时间；由商户生成后传入。取值范围：32 字符以下',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'WxPayFeedbackLog',
    @level2type = N'COLUMN',
    @level2name = N'TimeStamp'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'支付该笔订单的用户 ID，商户可通过公众号其他接口为付款用户服务',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'WxPayFeedbackLog',
    @level2type = N'COLUMN',
    @level2name = N'OpenId'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'字段名称：签名；字段来源：对前面的其他字段不 appKey按照字典序排序后，使用 SHA1 算法得到的结果。由商户生成后传入',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'WxPayFeedbackLog',
    @level2type = N'COLUMN',
    @level2name = N'AppSignature'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'通知类型  request  用户提交投诉  confirm  用户确认消除投诉  reject  用户拒绝消除投诉',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'WxPayFeedbackLog',
    @level2type = N'COLUMN',
    @level2name = N'MsgType'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'投诉单号',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'WxPayFeedbackLog',
    @level2type = N'COLUMN',
    @level2name = N'FeedBackId '
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'交易订单号',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'WxPayFeedbackLog',
    @level2type = N'COLUMN',
    @level2name = N'TransId'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'用户投诉原因',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'WxPayFeedbackLog',
    @level2type = N'COLUMN',
    @level2name = N'Reason'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'用户希望解决方案',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'WxPayFeedbackLog',
    @level2type = N'COLUMN',
    @level2name = N'Solution'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'备注信息+电话',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'WxPayFeedbackLog',
    @level2type = N'COLUMN',
    @level2name = N'ExtInfo'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'用户上传的图片凭证，最多五张;格式为JArray',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'WxPayFeedbackLog',
    @level2type = N'COLUMN',
    @level2name = N'PicUrl '
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'记录创建时间',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'WxPayFeedbackLog',
    @level2type = N'COLUMN',
    @level2name = N'RecCreateDt'